Creating a query from another Crystal Query

Accessing the Crystal SQL Designer

  1. From the Start menu, select Programs, select Crystal Reports Tools, then click Crystal SQL Designer.
  2. On the File menu, click New.

    The New Query dialog box appears.

  3. Click Start from existing Seagate Query.

  4. Select the query (*.QRY) file that you want to use as the base for your new query.
  5. Click OK.

    The program runs the existing SQL query and displays the data set.

  6. On the Edit menu, click Query.

    The Create SQL Expert appears with the specifications for the selected query already in place.

  7. Use the Create Query Expert to make any changes necessary to the query.
  8. Click Finish after completing all of the changes.
  9. Click Yes to process the query.

    The Crystal SQL Designer window appears with the results of your query.

  10. On the File menu, click Save As to specify a name for the new query.

    The new query is saved in a separate file; your source query remains unchanged.



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com